package io.renren.modules.contract.dao;

import io.renren.modules.contract.entity.CorporateCheckingEntity;
import io.renren.modules.sys.dao.BaseDao;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * 
 * 
 * @author chenshun
 * @email sunlightcs@gmail.com
 * @date 2019-12-13 16:17:47
 */
@Mapper
public interface CorporateCheckingDao extends BaseDao<CorporateCheckingEntity> {

    //根据收款合同统计收款金额
    @Select("select * from corporate_checking c where c.project_id = #{value}")
    CorporateCheckingEntity queryMoney(String receipt);
	
}
